Word macro: Memo

Excel macro: Headings


Excel macro: Headings
The Spreadsheet macro of the month is a macro which wraps the text in the selected cells and which is best used for Worksheet headings. The macro uses a short routine to process each cell in a given range of cells — for this reason, it is a handy macro as it shows you how you can process a range of cells one at a time. The macro is contained in the file Heading.xls and there is some sample text in that file you can use to test the macro. The file also contains instructions for attaching the macro to your own Personal.xls workbook.

Requirements: Microsoft Excel
Download: please insert disc 2